


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace PCS.Core {
	
        /// <summary>
        /// Table: Datas
        /// Primary Key: Name
        /// </summary>

        public class DatasTable: DatabaseTable {
            
            public DatasTable(IDataProvider provider):base("Datas",provider){
                ClassName = "Data";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("Value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });
                    
                
                
            }

            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Value{
                get{
                    return this.GetColumn("Value");
                }
            }
				
   			public static string ValueColumn{
			      get{
        			return "Value";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Questions
        /// Primary Key: Id
        /// </summary>

        public class QuestionsTable: DatabaseTable {
            
            public QuestionsTable(IDataProvider provider):base("Questions",provider){
                ClassName = "Question";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Content", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3000
                });

                Columns.Add(new DatabaseColumn("Answer", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("Status", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Date", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Count", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Content{
                get{
                    return this.GetColumn("Content");
                }
            }
				
   			public static string ContentColumn{
			      get{
        			return "Content";
      			}
		    }
            
            public IColumn Answer{
                get{
                    return this.GetColumn("Answer");
                }
            }
				
   			public static string AnswerColumn{
			      get{
        			return "Answer";
      			}
		    }
            
            public IColumn Status{
                get{
                    return this.GetColumn("Status");
                }
            }
				
   			public static string StatusColumn{
			      get{
        			return "Status";
      			}
		    }
            
            public IColumn Date{
                get{
                    return this.GetColumn("Date");
                }
            }
				
   			public static string DateColumn{
			      get{
        			return "Date";
      			}
		    }
            
            public IColumn Count{
                get{
                    return this.GetColumn("Count");
                }
            }
				
   			public static string CountColumn{
			      get{
        			return "Count";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Orders
        /// Primary Key: Id
        /// </summary>

        public class OrdersTable: DatabaseTable {
            
            public OrdersTable(IDataProvider provider):base("Orders",provider){
                ClassName = "Order";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2000
                });

                Columns.Add(new DatabaseColumn("Address", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2000
                });

                Columns.Add(new DatabaseColumn("Phone", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Email", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("Content", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3000
                });

                Columns.Add(new DatabaseColumn("Status", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Date", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Count", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Address{
                get{
                    return this.GetColumn("Address");
                }
            }
				
   			public static string AddressColumn{
			      get{
        			return "Address";
      			}
		    }
            
            public IColumn Phone{
                get{
                    return this.GetColumn("Phone");
                }
            }
				
   			public static string PhoneColumn{
			      get{
        			return "Phone";
      			}
		    }
            
            public IColumn Email{
                get{
                    return this.GetColumn("Email");
                }
            }
				
   			public static string EmailColumn{
			      get{
        			return "Email";
      			}
		    }
            
            public IColumn Content{
                get{
                    return this.GetColumn("Content");
                }
            }
				
   			public static string ContentColumn{
			      get{
        			return "Content";
      			}
		    }
            
            public IColumn Status{
                get{
                    return this.GetColumn("Status");
                }
            }
				
   			public static string StatusColumn{
			      get{
        			return "Status";
      			}
		    }
            
            public IColumn Date{
                get{
                    return this.GetColumn("Date");
                }
            }
				
   			public static string DateColumn{
			      get{
        			return "Date";
      			}
		    }
            
            public IColumn Count{
                get{
                    return this.GetColumn("Count");
                }
            }
				
   			public static string CountColumn{
			      get{
        			return "Count";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Packages
        /// Primary Key: Id
        /// </summary>

        public class PackagesTable: DatabaseTable {
            
            public PackagesTable(IDataProvider provider):base("Packages",provider){
                ClassName = "Package";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 7
                });

                Columns.Add(new DatabaseColumn("CustomerName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("Content", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });

                Columns.Add(new DatabaseColumn("Date", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
   			public static string CodeColumn{
			      get{
        			return "Code";
      			}
		    }
            
            public IColumn CustomerName{
                get{
                    return this.GetColumn("CustomerName");
                }
            }
				
   			public static string CustomerNameColumn{
			      get{
        			return "CustomerName";
      			}
		    }
            
            public IColumn Content{
                get{
                    return this.GetColumn("Content");
                }
            }
				
   			public static string ContentColumn{
			      get{
        			return "Content";
      			}
		    }
            
            public IColumn Date{
                get{
                    return this.GetColumn("Date");
                }
            }
				
   			public static string DateColumn{
			      get{
        			return "Date";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Users
        /// Primary Key: username
        /// </summary>

        public class UsersTable: DatabaseTable {
            
            public UsersTable(IDataProvider provider):base("Users",provider){
                ClassName = "User";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("username", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("password", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("role", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Byte,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn username{
                get{
                    return this.GetColumn("username");
                }
            }
				
   			public static string usernameColumn{
			      get{
        			return "username";
      			}
		    }
            
            public IColumn password{
                get{
                    return this.GetColumn("password");
                }
            }
				
   			public static string passwordColumn{
			      get{
        			return "password";
      			}
		    }
            
            public IColumn role{
                get{
                    return this.GetColumn("role");
                }
            }
				
   			public static string roleColumn{
			      get{
        			return "role";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: News
        /// Primary Key: Id
        /// </summary>

        public class NewsTable: DatabaseTable {
            
            public NewsTable(IDataProvider provider):base("News",provider){
                ClassName = "News";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("viTitle", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("enTitle", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("image", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 200
                });

                Columns.Add(new DatabaseColumn("viSummary", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3000
                });

                Columns.Add(new DatabaseColumn("enSummary", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 3000
                });

                Columns.Add(new DatabaseColumn("viContent", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("enContent", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("Type", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Date", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.DateTime,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("Count", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn viTitle{
                get{
                    return this.GetColumn("viTitle");
                }
            }
				
   			public static string viTitleColumn{
			      get{
        			return "viTitle";
      			}
		    }
            
            public IColumn enTitle{
                get{
                    return this.GetColumn("enTitle");
                }
            }
				
   			public static string enTitleColumn{
			      get{
        			return "enTitle";
      			}
		    }
            
            public IColumn image{
                get{
                    return this.GetColumn("image");
                }
            }
				
   			public static string imageColumn{
			      get{
        			return "image";
      			}
		    }
            
            public IColumn viSummary{
                get{
                    return this.GetColumn("viSummary");
                }
            }
				
   			public static string viSummaryColumn{
			      get{
        			return "viSummary";
      			}
		    }
            
            public IColumn enSummary{
                get{
                    return this.GetColumn("enSummary");
                }
            }
				
   			public static string enSummaryColumn{
			      get{
        			return "enSummary";
      			}
		    }
            
            public IColumn viContent{
                get{
                    return this.GetColumn("viContent");
                }
            }
				
   			public static string viContentColumn{
			      get{
        			return "viContent";
      			}
		    }
            
            public IColumn enContent{
                get{
                    return this.GetColumn("enContent");
                }
            }
				
   			public static string enContentColumn{
			      get{
        			return "enContent";
      			}
		    }
            
            public IColumn Type{
                get{
                    return this.GetColumn("Type");
                }
            }
				
   			public static string TypeColumn{
			      get{
        			return "Type";
      			}
		    }
            
            public IColumn Date{
                get{
                    return this.GetColumn("Date");
                }
            }
				
   			public static string DateColumn{
			      get{
        			return "Date";
      			}
		    }
            
            public IColumn Count{
                get{
                    return this.GetColumn("Count");
                }
            }
				
   			public static string CountColumn{
			      get{
        			return "Count";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Contents
        /// Primary Key: Id
        /// </summary>

        public class ContentsTable: DatabaseTable {
            
            public ContentsTable(IDataProvider provider):base("Contents",provider){
                ClassName = "Content";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int32,
	                IsNullable = false,
	                AutoIncrement = true,
	                IsForeignKey = false,
	                MaxLength = 0
                });

                Columns.Add(new DatabaseColumn("viName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("enName", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("viContent", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("enContent", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 1073741823
                });

                Columns.Add(new DatabaseColumn("Code", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 100
                });

                Columns.Add(new DatabaseColumn("Count", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Id{
                get{
                    return this.GetColumn("Id");
                }
            }
				
   			public static string IdColumn{
			      get{
        			return "Id";
      			}
		    }
            
            public IColumn viName{
                get{
                    return this.GetColumn("viName");
                }
            }
				
   			public static string viNameColumn{
			      get{
        			return "viName";
      			}
		    }
            
            public IColumn enName{
                get{
                    return this.GetColumn("enName");
                }
            }
				
   			public static string enNameColumn{
			      get{
        			return "enName";
      			}
		    }
            
            public IColumn viContent{
                get{
                    return this.GetColumn("viContent");
                }
            }
				
   			public static string viContentColumn{
			      get{
        			return "viContent";
      			}
		    }
            
            public IColumn enContent{
                get{
                    return this.GetColumn("enContent");
                }
            }
				
   			public static string enContentColumn{
			      get{
        			return "enContent";
      			}
		    }
            
            public IColumn Code{
                get{
                    return this.GetColumn("Code");
                }
            }
				
   			public static string CodeColumn{
			      get{
        			return "Code";
      			}
		    }
            
            public IColumn Count{
                get{
                    return this.GetColumn("Count");
                }
            }
				
   			public static string CountColumn{
			      get{
        			return "Count";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: Settings
        /// Primary Key: Name
        /// </summary>

        public class SettingsTable: DatabaseTable {
            
            public SettingsTable(IDataProvider provider):base("Settings",provider){
                ClassName = "Setting";
                SchemaName = "dbo";
                

                Columns.Add(new DatabaseColumn("Name", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 50
                });

                Columns.Add(new DatabaseColumn("Value", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.String,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2000
                });

                Columns.Add(new DatabaseColumn("Count", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 0
                });
                    
                
                
            }

            public IColumn Name{
                get{
                    return this.GetColumn("Name");
                }
            }
				
   			public static string NameColumn{
			      get{
        			return "Name";
      			}
		    }
            
            public IColumn Value{
                get{
                    return this.GetColumn("Value");
                }
            }
				
   			public static string ValueColumn{
			      get{
        			return "Value";
      			}
		    }
            
            public IColumn Count{
                get{
                    return this.GetColumn("Count");
                }
            }
				
   			public static string CountColumn{
			      get{
        			return "Count";
      			}
		    }
            
                    
        }
        
}